# # 设计数据库
#
#
# class User:
#     id = ''
#     username = ''
#     nickname = ''
#     password_hash = ''
#     phone = ''
#     email = ''
#
#
# class Sku:
#     id = ''
#     name = ''
#     sku_sn = ''
#     buy_price = ''
#     sell_price = ''
#     category_id = ''
#
#
# class Category:
#     id = ''
#     name = ''
#     parent_id = ''
#
#
# class Warehouse:
#     id = ''
#     name = ''
#
#
# class Order:
#     id = ''
#     order_sn = ''
#     order_type = ''  # 采购，销售
#     customer_id = ''
#     warehouse_id = ''
#     account_id = ''
#     income = ''
#     payment = ''
#
#     date = ''
#     status = ''  # 草稿，已完成，已撤销
#
#     tracking_number = ''
#     bill_info = ''
#
#
# class OrderItem:
#     id = ''
#     order_id = ''
#
#     sku_id = ''
#     price = ''
#     discount = ''
#     num = ''
#
#
# class StorageRecord:
#     id = ''
#     sku_id = ''
#     warehouse_id = ''
#     num = ''
#
#     cost_price = ''  # 库存成本单价
#
#
# class StorageFlowRecord:
#     id = ''
#     order_id = ''
#
#     sku_id = ''
#     warehouse_id = ''
#     before_num = ''
#     after_num = ''
#
#
# class Account:
#     id = ''
#     name = ''
#     account_no = ''
#     owner = ''  # 持卡人
#     account_type = ''  # 现金，支付宝，银行卡
#     balance_now = ''  # 当前余额
#
#
# class FinanceRecord:
#     id = ''
#     order_id = ''
#
#     account_id = ''
#     customer_id = ''
#     should_income = ''
#     income = ''
#     should_payment = ''
#     payment = ''
#
#     transaction_datetime = ''
